使用PHP连接到远程MySQL服务器-ConnectingtoremoteMySQLserverusingPHP

17  

• firewall of the server must be set-up to enable incomming connections on port 3306
• 必须设置服务器的防火墙以启用端口3306上的连接
• you must have a user in MySQL who is allowed to connect from % (any host) (see manual for details)
• 您必须在MySQL中拥有一个允许从％（任何主机）连接的用户（有关详细信息，请参阅手册）

The current problem is the first one, but right after you resolve it you will likely get the second one.

目前的问题是第一个问题，但在您解决问题之后，您可能会得到第二个问题。

3  

It is very easy to connect remote MySQL Server Using PHP, what you have to do is:

使用PHP连接远程MySQL服务器非常容易，您需要做的是：

1. Create a MySQL User in remote server.

   在远程服务器中创建MySQL用户。

2. Give Full privilege to the User.

   为用户授予完全权限。

3. Connect to the Server using PHP Code (Sample Given Below)

   使用PHP代码连接到服务器（下面给出的示例）

$link = mysql_connect('your_my_sql_servername or IP Address', 'new_user_which_u_created', 'password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';

mysql_select_db('sandsbtob',$link) or die ("could not open db".mysql_error());
// we connect to localhost at port 3306

2  

I just solved this kind of a problem. What I've learned is:

我刚刚解决了这个问题。我学到的是：

1. you'll have to edit the my.cnf and set the bind-address = your.mysql.server.address under [mysqld]
2. 你必须编辑my.cnf并在[mysqld]下设置bind-address = your.mysql.server.address
3. comment out skip-networking field
4. 评论跳过网络领域
5. restart mysqld
6. 重启mysqld

7. check if it's running

   检查它是否正在运行

   mysql -u root -h your.mysql.server.address –p 
   

8. create a user (usr or anything) with % as domain and grant her access to the database in question.

   使用％作为域创建用户（usr或任何东西）并授予她对相关数据库的访问权限。

   mysql> CREATE USER 'usr'@'%' IDENTIFIED BY 'some_pass';
   mysql> GRANT ALL PRIVILEGES ON testDb.* TO 'monty'@'%' WITH GRANT OPTION;
   

9. open firewall for port 3306 (you can use iptables. make sure to open port for eithe reveryone, or if you're in tight securety, then only allow the client address)

   打开端口3306的防火墙（你可以使用iptables。确保打开端口以便进行复制，或者如果你的安全性很高，那么只允许客户端地址）

10. restart firewall/iptables
11. 重启firewall / iptables

you should be able to now connect mysql server form your client server php script.

你应该能够现在连接mysql服务器从客户端服务器PHP脚本。

0  

This maybe not the answer to poster's question.But this may helpful to people whose face same situation with me:

这可能不是海报问题的答案。但这可能对那些与我面临同样情况的人有所帮助：

The client have two network cards,a wireless one and a normal one. The ping to server can be succeed.However telnet serverAddress 3306 would fail. And would complain

客户端有两个网卡，一个是无线网卡，另一个是普通网卡。 ping到服务器可以成功。但telnet serverAddress 3306将失败。并会抱怨

Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060)

无法连接到'xxx.xxx.xxx.xxx'上的MySQL服务器（10060）

when try to connect to server.So I forbidden the normal network adapters. And tried telnet serverAddress 3306 it works.And then it work when connect to MySQL server.

当试图连接到服务器。所以我禁止正常的网络适配器。并尝试telnet serverAddress 3306它的工作原理。然后它连接到MySQL服务器时工作。